UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iQ49oO+txBhut05Z2BM/iYNp3vnb8wIaWCVaxhxVVrU='
WHERE
key_id = '789ceead2d7b4a97b79574ab0b5e1dc4b98e6f3c8dfd7cbe147dfedd8b2fd7c2'
AND (
token = 'iQ49oO+txBhut05Z2BM/iYNp3vnb8wIaWCVaxhxVVrU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)