UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qA1rXcTXFI717fC/GZLobPNP7ofB7zBAfwT9OHD8EH8='
WHERE
key_id = '647bac576633bce166a103fd8054d0c48485dc3d5d3d042e49e179eda245981b'
AND (
token = 'qA1rXcTXFI717fC/GZLobPNP7ofB7zBAfwT9OHD8EH8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)