UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CHLZyxV7zIjOrjsBSALsqVJs3BzV9awDsv5j0O5ubZg='
WHERE
key_id = 'fb882c4cec30eb9db97e1fe5fb31c2a2bc122b139c5e40e8307e2b115477c5fa'
AND (
token = 'CHLZyxV7zIjOrjsBSALsqVJs3BzV9awDsv5j0O5ubZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)