UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kJtakXO3glt4OCgZefvnoGcUqlza1fKOitSuVLhMd+w='
WHERE
key_id = '564a1b66fab154e650fc90bada4440e1215845f6bd592b22d98eedf10aa852f4'
AND (
token = 'kJtakXO3glt4OCgZefvnoGcUqlza1fKOitSuVLhMd+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)