UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2QlCujpwc4E9HHtf1Pj62tpLAEnwCcC5aPPrEIPOFTc='
WHERE
key_id = '83a6e1f18143726ba1350c48e3655b3fb97e0cfd8b5c0e37c389f9a00fea3272'
AND (
token = '2QlCujpwc4E9HHtf1Pj62tpLAEnwCcC5aPPrEIPOFTc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)