UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yAvhnEgKI9rcLkMX36yCM4SjbxDYG8KOKS+qq+0lFks='
WHERE
key_id = 'bca9896c270e26637e2920b0984b4811f58f7c61dc1c742cd8caf3fe8a8cb58b'
AND (
token = 'yAvhnEgKI9rcLkMX36yCM4SjbxDYG8KOKS+qq+0lFks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)