UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DSmYsoErJZw378Hg2/cITuvxv/2WuE+N30jZuojSNzw='
WHERE
key_id = '734c166013b128aa025e685f9464847ff27e38b59fea37ae9e2e59d63c83b3d1'
AND (
token = 'DSmYsoErJZw378Hg2/cITuvxv/2WuE+N30jZuojSNzw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)