UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xZLOF2RFC1pFUjNU8IyL6ErZzWBWQKXShgxsSd9JiCw='
WHERE
key_id = '19ed5e3dbbb48298472cbeb17406070a16f13be4c91411649c0a20883aaf7e93'
AND (
token = 'xZLOF2RFC1pFUjNU8IyL6ErZzWBWQKXShgxsSd9JiCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)