UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OHsP0H9Ci9Fl6cDbeifk/TUd6gFLyZ0SbWYQNToZnuA='
WHERE
key_id = '47af5e705e30787b57ac2da10be2f46f4ab186cc649475572cfd58af53b1ce6b'
AND (
token = 'OHsP0H9Ci9Fl6cDbeifk/TUd6gFLyZ0SbWYQNToZnuA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)