UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vrXuJ8XmZl7zcI3YNGcBBFQybkIQ+lXN7+2UBemjmf4='
WHERE
key_id = 'bc15c1c3828bbba56da39b26f7370914ad61f77c21c786ab4808a8562d054da1'
AND (
token = 'vrXuJ8XmZl7zcI3YNGcBBFQybkIQ+lXN7+2UBemjmf4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)