UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QV/+0xEPmY2/+GwcLSXngW/o7It62JMt++QI3A3nh4E='
WHERE
key_id = '33693bbb1a85da4ec1c48a846d32874ffcbe6e580e963effb1e70fd0403c40c4'
AND (
token = 'QV/+0xEPmY2/+GwcLSXngW/o7It62JMt++QI3A3nh4E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)