UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+NJGjLiXkpkyizxtmgkiizHBvpTgDn/VGMoI+/MlxVo='
WHERE
key_id = 'd40a564147bc8db9dcfee39ff83791b0715fecc737e0a113ed347249a0484970'
AND (
token = '+NJGjLiXkpkyizxtmgkiizHBvpTgDn/VGMoI+/MlxVo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)