UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NRMkNsL456mU8ieDLrVXEt1ZuJrQKg2NGwiM99326uo='
WHERE
key_id = '0227e0f16142216f019fb13b5f72e3ddd3c2658daeead0f8e2eb7291c6404388'
AND (
token = 'NRMkNsL456mU8ieDLrVXEt1ZuJrQKg2NGwiM99326uo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)