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