UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xq5NvBMHJyi7TbtRU4di/mOYvljtZYQKiAsNiRFVYRI='
WHERE
key_id = 'ca97b0828b7ae507c2b069f0041fccf45495fe49a3f3c908f6b4fe41e8dccbe2'
AND (
token = 'Xq5NvBMHJyi7TbtRU4di/mOYvljtZYQKiAsNiRFVYRI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)