UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7HZ+sZZADo058iCZNCe8jhN7A2ZuiLSS9GGOCnVv1rI='
WHERE
key_id = '8d35279696bb8832baf498aa86db01d6095646b3d405fd06d8cb4c937e0ad720'
AND (
token = '7HZ+sZZADo058iCZNCe8jhN7A2ZuiLSS9GGOCnVv1rI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)