UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7GQy8Tu9ykkMDKhxt0Y3nx+S5rEGP+yxiixPK/jc1hA='
WHERE
key_id = '5456dc80c750979b3128c503d722ec7ed000b58acbc69f5bb461fa4eb49ff469'
AND (
token = '7GQy8Tu9ykkMDKhxt0Y3nx+S5rEGP+yxiixPK/jc1hA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)