UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HdA9teOYK/51rWJh6oMsdhX7yLS7pDHiUkMVCPqQZuk='
WHERE
key_id = 'a9db3ca5e1d05ed258d5d6a89abc6edc55dc3f34d2e0384bca448a30fe3507b4'
AND (
token = 'HdA9teOYK/51rWJh6oMsdhX7yLS7pDHiUkMVCPqQZuk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)