UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4gXtH16wCc4tUSKZBVjpfwV4zH5WDuMoXP7hp1stscA='
WHERE
key_id = '0f89341a6034118d9bf13c541a193e3d36063c38996d3d92ad5fd0b54b05c562'
AND (
token = '4gXtH16wCc4tUSKZBVjpfwV4zH5WDuMoXP7hp1stscA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)