UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+oZz1K1E9h62jB8WMsWqyEm90wDnfhixsTE5t0qfohI='
WHERE
key_id = '31e051bcec1158fb30dcbe0f94d59a4f77e571855bff24526437cbb1774c74ed'
AND (
token = '+oZz1K1E9h62jB8WMsWqyEm90wDnfhixsTE5t0qfohI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)