UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZPCsaaywho9hwk3IeFmwwhAkWS6I4m8QgrVYwxq3CsI='
WHERE
key_id = 'f3f49c80af96a128ac2869b2aef1a50f1adbddb73fdfdcef3fa1c2c663891a8f'
AND (
token = 'ZPCsaaywho9hwk3IeFmwwhAkWS6I4m8QgrVYwxq3CsI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)