UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iGtdxSCVFLxqLtv8QKVOXg4WUGmYylJYXeYGCN3SQxg='
WHERE
key_id = '04b7f9a435e86a368ca1135a0ac88e261084c788788108b12288f92bf9d0b2a6'
AND (
token = 'iGtdxSCVFLxqLtv8QKVOXg4WUGmYylJYXeYGCN3SQxg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)