UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pXk9MIhBRWQgG+ynwU8cYyqvsqIQ6BOkZoReFHo0o+U='
WHERE
key_id = '5c2a919ba8d54bafa4de46dfd74d15b5bd4679c8b573258175e26c2732a98970'
AND (
token = 'pXk9MIhBRWQgG+ynwU8cYyqvsqIQ6BOkZoReFHo0o+U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)