UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0/1lSjJi7LOqIIdf8jaKKMG7KZ2NAUGd5E761hMV/LA='
WHERE
key_id = '029608da8b70b26ff5e71585f0a94f56e4e73c38310d2bc81359f6a3427f2d97'
AND (
token = '0/1lSjJi7LOqIIdf8jaKKMG7KZ2NAUGd5E761hMV/LA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)