UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pHxBagCauQwlhkgN/9OiKZol8JYtDdXPF5PwEkRSQAw='
WHERE
key_id = 'cf5dec3eb53e0313e38638a9f2db8518221d32587dd4b0ead076fd2db64de670'
AND (
token = 'pHxBagCauQwlhkgN/9OiKZol8JYtDdXPF5PwEkRSQAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)