UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x2M40LJ/2Y8FNo46aiLNgsuJepn1oP4w+QmTwYhucWY='
WHERE
key_id = 'd4780db99cd0a7273f3fe5a969ef3219f40c27f6acc075ccea34edfed061f16a'
AND (
token = 'x2M40LJ/2Y8FNo46aiLNgsuJepn1oP4w+QmTwYhucWY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)