UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ems1nPvxOftc3iWtYqIFYfO1TN71RgXtdNqjG+S29MA='
WHERE
key_id = 'f9ca8a70600b34b7fc8ad85b89b66e9990b04fa3ca48d194d040990d527cb320'
AND (
token = 'Ems1nPvxOftc3iWtYqIFYfO1TN71RgXtdNqjG+S29MA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)