UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '52nGMO+HzKd/XcmH6ZoUmdNMRcoIEwJd6CTrx6yXiok='
WHERE
key_id = 'b64d927ba1a26f8543c658689dbac22c6dfbd7528f7065f7d803f7d96f377000'
AND (
token = '52nGMO+HzKd/XcmH6ZoUmdNMRcoIEwJd6CTrx6yXiok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)