UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tj3DpOpfwZA+7q/FD4cWtB28kknig/spwpciTio1qvU='
WHERE
key_id = 'd6fa96caf98c4ca197164d6cf704a48ef8355e3d5c871f6e6f9c97013ca5ddc2'
AND (
token = 'tj3DpOpfwZA+7q/FD4cWtB28kknig/spwpciTio1qvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)