UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gfwKPz16h6pFPZCD3v0pWtbwg0CfFxSwEJ0jIe7ZfLQ='
WHERE
key_id = '2c2a3cb8f1e034df8e052ee625a0ccf60266105ca995e51d4a67366073df05f9'
AND (
token = 'gfwKPz16h6pFPZCD3v0pWtbwg0CfFxSwEJ0jIe7ZfLQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)