UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xHvZaTxsLxNVnRs774rFJc52aZtXPYrunHtuL5QVCYk='
WHERE
key_id = '564c089dcc14b29604d3090bfbbd34be359b034b822b7a37de2255bec3333ebb'
AND (
token = 'xHvZaTxsLxNVnRs774rFJc52aZtXPYrunHtuL5QVCYk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)