UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a1j3Pmk8z86WAL4Jdcdkq1Wi77KMsLKOMgiV3NQWi/I='
WHERE
key_id = '9a7ad254b64936b8ba04b5326d8530340154523981feaa884cceb1bf9102f937'
AND (
token = 'a1j3Pmk8z86WAL4Jdcdkq1Wi77KMsLKOMgiV3NQWi/I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)