UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1kJHondWonrBm0TMXhVpEGCFs22qypTmexjlsTYNHg4='
WHERE
key_id = '3bb02d779e24f1d14e73a46fc2a7d5b3b5c5f77a39c303ce14bc9405314676b2'
AND (
token = '1kJHondWonrBm0TMXhVpEGCFs22qypTmexjlsTYNHg4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)