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