UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dmmBxWCN4pS3YEBAaL1sHT/1KlX8E8dkC8hzGS1aRV0='
WHERE
key_id = 'f39dc5477ac8f20d3e3b21b129730f86a4c7704c158bbc798a897167d69d931e'
AND (
token = 'dmmBxWCN4pS3YEBAaL1sHT/1KlX8E8dkC8hzGS1aRV0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)