UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L9Ck9Cf0zyTUkeI3y5nfdDUWgG7I5PUtiW85779Iua4='
WHERE
key_id = 'dbe24fc3d31097d801abe873f71225f9075cee25cc54a327946c27925fb3d6ec'
AND (
token = 'L9Ck9Cf0zyTUkeI3y5nfdDUWgG7I5PUtiW85779Iua4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)