UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nW186YvVhaZ2YrrsXstKjgQOfw+4+Im+ADGNHXDdOaM='
WHERE
key_id = 'c034c32431f7a7158c10f5d97772bd462cc547126c330f2fc8346ef0fd9c077b'
AND (
token = 'nW186YvVhaZ2YrrsXstKjgQOfw+4+Im+ADGNHXDdOaM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)