UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U1iT+ACXqJURGjdkKtp4bxVqt41/pZLt9pqh7aPggKQ='
WHERE
key_id = '78a05e8e46385c9805858f48a0a9dd5d2968e606c4b4bd92d42c0b1100f369c4'
AND (
token = 'U1iT+ACXqJURGjdkKtp4bxVqt41/pZLt9pqh7aPggKQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)