UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8JWvV06HS5dN0Ba/UnQ0XrMHYY+Eiqy7TfVl1Sn4DKA='
WHERE
key_id = 'd402ba6de7d5c76299401d8711610295dab3087201ca73c077e978e7ea4ef7ec'
AND (
token = '8JWvV06HS5dN0Ba/UnQ0XrMHYY+Eiqy7TfVl1Sn4DKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)