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