UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6zwXpmdu/ciaavbDAr9BnCwacAvKyhrthn+cTC7R8Fg='
WHERE
key_id = 'd7155ac590332c10033f715b2a76e5f2749066ff52327e45ff6abb82d7fa2a7a'
AND (
token = '6zwXpmdu/ciaavbDAr9BnCwacAvKyhrthn+cTC7R8Fg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)