UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q0ERwnobyg6cYGH8THJXJGqpaf2raFSm9+u63NeTzhI='
WHERE
key_id = '2f420729401b21583311f9e2cc5a4307479733adbdedcc3f16f3ecf8454dd792'
AND (
token = 'q0ERwnobyg6cYGH8THJXJGqpaf2raFSm9+u63NeTzhI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)