UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XF8vRg6QgGK/hxASUgvoU5fMf4WDYM2UGBMXtMHbUv8='
WHERE
key_id = '581a8f184c02da2144010902abf3fa8f83bde00f8824030ddc702715f7c84170'
AND (
token = 'XF8vRg6QgGK/hxASUgvoU5fMf4WDYM2UGBMXtMHbUv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)